Upgrading Database Error

IONE 6.0.1SPM 7.0.1PME 7.2.2 - Upgrade to PME 8.2 - Failed on Step: Checking Space

Issue: When trying to upgrade IONE 6.0.1SPM 7.0.1PME 7.2.2 to PME 8.2, the process was unsuccessful at the Checking Space step.

The following entries may be seen in the Error Log:

System.ArgumentException: Illegal characters in path.
at System.IO.Path.CheckInvalidPathChars(String path, Boolean checkAdditional)
at System.IO.Path.NormalizePath(String path, Boolean fullCheck, Int32 maxPathLength, Boolean expandShortPaths)
at System.IO.Path.GetFullPathInternal(String path)
at System.IO.FileInfo.Init(String fileName, Boolean checkHost)
at System.IO.FileInfo..ctor(String fileName)
at Installer.InstallTools.ConfigureSQL.GetDBFilePhysicalPath(String dbName)
at Installer.InstallRequests.CheckDiskSpaceGenericRequest.DoJob()

executeQuery(SELECT filename FROM sysdatabases WHERE name = 'ION_Data', master) Failed on exception:
\nSystem.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
at Installer.InstallTools.ConfigureSQL.ExecuteScalar(SqlCommand command, String dbName)

Cause: SQL user ION needs Sysadmin level user privileges and the SQL Server services need to be running under the "Local System" account.

Resolution: Complete these steps:

  1. Login to SQL Management Console with a Sysadmin level user.
  2. In Security\Logins, double click on the ION user to bring up the Login Properties window.
  3. Select Server Roles, and check sysadmin on the right side, then click OK.
  4. Open Windows Services.
  5. Right-click on the SQL Server service and select Properties.
  6. In the Properties window, select the Log On tab, check Log on as Local System account, then click OK.
  7. Do this to the SQL Agent also and then restart the SQL and SQL Agent services.
  8. Re-run the upgrade.